import openpyxl
import os
file_path=os.path.dirname(os.path.abspath(__file__))
base_path=file_path+'/链家出租房信息表.xlsx'
wb=openpyxl.load_workbook(base_path)
worksheet=wb['Sheet']
#第0列的值
col0=[item.value for item in list(worksheet.columns)[0]]
print(col0)
#第0行的值
row0=[item.value for item in list(worksheet.rows)[0]]
print(row0)
#第0行第0列的值
cell_0_0=worksheet.cell(row=1,column=1).value
print(cell_0_0)